forum

Home / DeveloperSection / Forums / Which SQL command to get all details about a table in Oracle?

Ask Question
Utpal Vishwas

Utpal Vishwas

Follow
I am Utpal Vishwas from Uttar Pradesh. Have completed my B. Tech. course from MNNIT campus Prayagraj in 2022. I have good knowledge of computer networking.

Can you answer this question?

Answer

1 Answers

Aryan Kumar

Aryan Kumar

18-Jul-2023

To get all details about a table in Oracle, you can use the DESCRIBE command. The DESCRIBE command will return a list of all the columns in the table, as well as their data types, sizes, and other properties.

For example, to get all details about the table employees, you would use the following command:

SQL

DESCRIBE employees;

This would return a list of all the columns in the employees table, as well as their data types, sizes, and other properties.

Here is an example of the output of the DESCRIBE command:

SQL

COLUMN_NAME                    DATA_TYPE         PRECISION  SCALE       NULLABLE
-----------------------------  --------------  --------  --------  --------
employee_id                   NUMBER         10         0          N
first_name                    VARCHAR2       255         0          Y
last_name                     VARCHAR2       255         0          Y
email                          VARCHAR2       255         0          Y
phone_number                   VARCHAR2       255         0          Y
hire_date                     DATE           0          0          N

The DESCRIBE command is a powerful tool that you can use to get information about tables in Oracle. By using the DESCRIBE command, you can learn about the structure of a table and the data that it contains.

MindStick Training

Liked By